object furarizacik: Tfurarizacik
  Tag = 76
  Left = 182
  Top = 110
  BorderIcons = [biSystemMenu, biMinimize]
  BorderStyle = bsSingle
  Caption = #220'retimden Ar'#305'zaya '#199#305'k'#305#351
  ClientHeight = 519
  ClientWidth = 942
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  FormStyle = fsMDIChild
  KeyPreview = True
  OldCreateOrder = False
  Position = poDefaultPosOnly
  Visible = True
  OnClose = FormClose
  OnKeyDown = FormKeyDown
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Panel2: TPanel
    Left = 0
    Top = 482
    Width = 942
    Height = 37
    Align = alBottom
    TabOrder = 0
    DesignSize = (
      942
      37)
    object cikisambaril: TLabel
      Left = 288
      Top = 11
      Width = 58
      Height = 14
      Caption = #199#305'k'#305#351' Ambar'#305
    end
    object girisambaril: TLabel
      Left = 472
      Top = 11
      Width = 58
      Height = 14
      Caption = 'Giri'#351' Ambar'#305
    end
    object byenile: TBitBtn
      Left = 8
      Top = 6
      Width = 69
      Height = 25
      Caption = 'Listele-F5'
      TabOrder = 0
      OnClick = byenileClick
    end
    object BitBtn2: TBitBtn
      Left = 648
      Top = 7
      Width = 73
      Height = 25
      Caption = 'G'#246'nder'
      TabOrder = 1
      OnClick = BitBtn2Click
    end
    object btumunusec: TBitBtn
      Left = 84
      Top = 6
      Width = 72
      Height = 25
      Caption = 'T'#252'm'#252'n'#252' Se'#231
      TabOrder = 2
      OnClick = btumunusecClick
    end
    object bkapat: TBitBtn
      Left = 870
      Top = 6
      Width = 64
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      TabOrder = 3
      OnClick = bkapatClick
    end
    object cikisambarik: TwwDBLookupCombo
      Left = 356
      Top = 9
      Width = 101
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'DepoAdi'#9'20'#9'Depo Ad'#305#9#9)
      LookupTable = dm.AmbarQ
      LookupField = 'id'
      Style = csDropDownList
      Navigator = False
      ReadOnly = True
      TabOrder = 4
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
    end
    object girisambarik: TwwDBLookupCombo
      Left = 536
      Top = 9
      Width = 97
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'DepoAdi'#9'20'#9'Depo Ad'#305#9'F'#9)
      LookupTable = AmbarQ
      LookupField = 'id'
      Style = csDropDownList
      Navigator = False
      TabOrder = 5
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
    end
    object btParcala: TBitBtn
      Left = 757
      Top = 6
      Width = 88
      Height = 25
      Caption = 'Par'#231'ala'
      TabOrder = 6
      OnClick = btParcalaClick
    end
  end
  object cxGrid1: TcxGrid
    Left = 0
    Top = 0
    Width = 942
    Height = 482
    Align = alClient
    TabOrder = 1
    object cxGrid1DBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      OnCustomDrawCell = cxGrid1DBTableView1CustomDrawCell
      DataController.DataSource = UretimArizaQS
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Inserting = False
      object cxGrid1DBTableView1selected: TcxGridDBColumn
        Caption = 'Se'#231
        DataBinding.FieldName = 'selected'
        PropertiesClassName = 'TcxCheckBoxProperties'
        Properties.NullStyle = nssUnchecked
        Width = 41
      end
      object cxGrid1DBTableView1eSeriNo: TcxGridDBColumn
        Caption = 'E.SeriNo'
        DataBinding.FieldName = 'eSeriNo'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 148
      end
      object cxGrid1DBTableView1Grup: TcxGridDBColumn
        DataBinding.FieldName = 'Grup'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 105
      end
      object cxGrid1DBTableView1stokkodu: TcxGridDBColumn
        Caption = 'Stok Kodu'
        DataBinding.FieldName = 'stokkodu'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 140
      end
      object cxGrid1DBTableView1personel: TcxGridDBColumn
        Caption = 'Personel'
        DataBinding.FieldName = 'personel'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 117
      end
      object cxGrid1DBTableView1islemtarihi: TcxGridDBColumn
        Caption = 'Tarih'
        DataBinding.FieldName = 'islemtarihi'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 60
      end
      object cxGrid1DBTableView1arizasi: TcxGridDBColumn
        Caption = 'Ar'#305'zas'#305
        DataBinding.FieldName = 'arizasi'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 116
      end
      object cxGrid1DBTableView1carikodu: TcxGridDBColumn
        Caption = 'Carikodu'
        DataBinding.FieldName = 'carikodu'
        Options.Editing = False
        Options.Focusing = False
        Options.IncSearch = False
        Options.Moving = False
        Width = 138
      end
      object cxGrid1DBTableView1DOA: TcxGridDBColumn
        DataBinding.FieldName = 'DOA'
        PropertiesClassName = 'TcxCheckBoxProperties'
        Properties.NullStyle = nssUnchecked
        Options.Editing = False
      end
      object cxGrid1DBTableView1DOAAmbar: TcxGridDBColumn
        Caption = 'DOA AMBAR'
        Visible = False
      end
      object cxGrid1DBTableView1DoaKalanGun: TcxGridDBColumn
        Caption = 'DOA Kalan Gun'
        DataBinding.FieldName = 'DoaKalanGun'
      end
    end
    object cxGrid1Level1: TcxGridLevel
      GridView = cxGrid1DBTableView1
    end
  end
  object UretimArizaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'Select selected,id,kayitno,stokkod,eSeriNo,dbo.getstokkodu(stokk' +
        'od) as stokkodu,dbo.getcinsi(stokkod) as cinsi,Makinano,perkod,p' +
        'ersonel=(select adi+'#39' '#39'+soyadi from perkart where perkart.perkod' +
        '=UretimAriza.Perkod),'
      
        '(select isim from stgruptanim where id in (Select GrupId from st' +
        'ok where Stokkod=UretimAriza.Stokkod)) Grup,Parcalama,DurumDegis' +
        'Zaman,Doa,DoaAmbar,'
      
        'DoaKalanGun=DATEDIFF(dd,GetDate(),DateAdd(mm,(Select isnull(DOA,' +
        '0) FROM Stok Where Stokkod=UretimAriza.Stokkod),(Select (Select ' +
        'isnull(Tarih,'#39'2000-01-01'#39') from Fatura Where BilisNo=fatharhar.B' +
        'ilisNogir) From Fatharhar where serinos=uretimariza.eserino))),'
      
        'islemtarihi,arizasi,durum,ySerino,cambar,gambar,carikodu=(select' +
        ' dbo.getcarikodu(carikod) from fatura where bilisno=(select bili' +
        'snogir from fatharhar f where f.serinos=uretimariza.eserino)) fr' +
        'om UretimAriza '
      'where durum=1'
      'order by stokkodu desc')
    Left = 344
    Top = 168
  end
  object UretimArizaQS: TDataSource
    DataSet = UretimArizaQ
    Left = 336
    Top = 112
  end
  object StokFisiQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    SQL.Strings = (
      'Select * from StokFisi where id is null')
    Left = 504
    Top = 48
  end
  object StokFisiHarQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    SQL.Strings = (
      'Select * from StokFisihar where id is null')
    Left = 432
    Top = 48
  end
  object StokUpdateQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    Left = 624
    Top = 48
  end
  object AmbarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from depolar'
      'Where id in (2,3,12)')
    Left = 209
    Top = 64
  end
  object StokFisiharharQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    SQL.Strings = (
      'Select * from stokfisiharhar where id is null')
    Left = 433
    Top = 109
  end
end
